This report is meant to run a data quality check through out the CDP questions that are related to **Waste data**.
| Number of cities that responded per indicator | ||
| Indicator | Responses | |
|---|---|---|
| Amount | Percentage | |
| Percentage of the diverted solid waste generated that is recycled (%) | 59 | 75.6% |
| Percentage of the diverted solid waste generated that is reused (%) | 23 | 29.5% |
| Percentage of the total solid waste generated that is diverted away from landfill and incineration (%) | 61 | 78.2% |
| Percentage of the total solid waste generated that is utilized for waste to energy (%) | 48 | 61.5% |
| Percentage of waste collected where separation at source is taking place (%) | 40 | 51.3% |
| Percentage of wastewater safely treated to at least secondary level (%) | 44 | 56.4% |
| Total amount of solid waste generated (tonnes/year) | 76 | 97.4% |
| Total annual amount of food waste produced in the jurisdiction (tonnes/year) | 52 | 66.7% |
| Volume of wastewater produced within the jurisdiction boundary (megalitres/year) | 51 | 65.4% |
| Data Quality Report | |||||||||||||
| QA checks - Check columns structure
tibble
waste cdp questionsWARN
0.00
STOP
—
NOTIFY
—
|
|||||||||||||
| STEP | COLUMNS | VALUES | TBL | EVAL | UNITS | PASS | FAIL | W | S | N | EXT | ||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 15 | Check that columns is numeric
|
— |
|
✓ |
1 |
00.00 |
11.00 |
● |
— |
— |
— | ||
| 16 | Check that columns is numeric
|
— |
|
✓ |
1 |
00.00 |
11.00 |
● |
— |
— |
— | ||
| 17 | Check that column in integer
|
— |
|
✓ |
1 |
00.00 |
11.00 |
● |
— |
— |
— | ||
| 18 | Check that column in integer
|
— |
|
✓ |
1 |
00.00 |
11.00 |
● |
— |
— |
— | ||
| 2024-07-01 17:20:46 -03 < 1 s 2024-07-01 17:20:46 -03 | |||||||||||||
| Data Quality Report | |||||||||||||
| QA checks - Check question value’s quality
tibble
Waste cdp questionsWARN
0.00
STOP
—
NOTIFY
—
|
|||||||||||||
| STEP | COLUMNS | VALUES | TBL | EVAL | UNITS | PASS | FAIL | W | S | N | EXT | ||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2 | Check that year col is between 2000 and current 2024
|
|
✓ |
488 |
4870.99 |
10.01 |
● |
— |
— |
||||
| 4 | Check that values containg numbers only
|
|
✓ |
488 |
4870.99 |
10.01 |
● |
— |
— |
||||
| 6 | Check that values containg numbers only
|
|
✓ |
488 |
4870.99 |
10.01 |
● |
— |
— |
||||
| 7 | Check comments where the word wrong or probably/likely wrong is mentioned
|
|
✓ |
488 |
4680.96 |
200.04 |
● |
— |
— |
||||
| 8 | Check comments where the word wrong or probably/likely wrong is mentioned
|
|
✓ |
488 |
4810.99 |
70.01 |
● |
— |
— |
||||
| 9 | Check that percentage indicator's values are between 0 and 100
|
|
✓ |
302 |
2890.96 |
130.04 |
● |
— |
— |
||||
| 10 | Check that percentage indicator's values are between 0 and 100
|
|
✓ |
302 |
2980.99 |
40.01 |
● |
— |
— |
||||
| 2024-07-01 17:20:46 -03 < 1 s 2024-07-01 17:20:46 -03 | |||||||||||||